package com.osdp.uc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.osdp.uc.entity.UcOrganization;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UcOrganizationMapper extends BaseMapper<UcOrganization> {

    @Select("select * from uc_organization uo left join sc_role_position uup on uo.id = uup.org_id where uup.user_id = #{userId}")
    List<UcOrganization> queryOrganizationByUserId(String userId);
}
